2013-03-07 - 4257.100 - Rel Notes - Payroll Rate Change Procedure #DotNetReleases2013
Release Notes
4257.100 - Payroll Rate Change Procedure
Admin Info
Purpose
|
Payroll Rate Change Procedure
|
Release No#
|
001
|
Submitted on
|
03/07/2013
|
Submitted by
|
Venkat A
|
Source/Destination Systems
|
Local/NEC DEV
|
Release Sent To
|
Juanita
|
Objects Created By
|
Venkat A
|
Objects Tested By
|
Rajesh K
|
Transport and Technical Objects
Location Objects Name
|
\\10.114.165.54\sites\Deployments\BMS POLCA RELEASES\POLCA ENHANCEMENTS_03072013\
- Bus_Unit_Data.aspx
- Bus_Unit_Data.aspx.cs
- Script.sql
|
Release Notes
For Infrastructure
Please take backup of existing pages in Dev.
- MasterData/Bus_Unit_Data.aspx
- MasterData/Bus_Unit_Data.aspx.cs
Take Back up of below mentioned DB objects before running the script
|
Type
|
Name
|
1
|
Table
|
PS_NEC_BUS_UNIT_DT
|
2
|
Stored Procedure
|
CALC_EMP_RATES
|
3
|
Stored Procedure
|
USP_BU_GET
|
4
|
Stored Procedure
|
USP_BUDT_INSERT
|
5
|
Stored Procedure
|
USP_HR_REVIEWOPERATION_REPORT
|
6
|
Stored Procedure
|
USP_NECRATE_RATESQL
|
7
|
Stored Procedure
|
USP_RAPIDENTRY_INSRTUPDAT
|
8
|
Stored Procedure
|
Usp_revemp_lotsize_change
|
Run the below attached Sql Script on Dev DB in the given sequence:
Move the following pages to DEV
|
Type
|
Name
|
1
|
Page
|
Bus_Unit_Data.aspx
|
2
|
Page
|
Bus_Unit_Data.aspx.cs
|
Note: Take back up of all above mentioned before doing changes.
For Requestor
Following objects got updated
|
Type
|
Name
|
Change
|
1
|
Page
|
Bus_Unit_Data.aspx,
Bus_Unit_Data.aspx.cs
|
- Added labels and textbox for Tier 3 Standard Base Rate, Tier 3 Floater Base Rate
- Changed label Standard Base Rate to Tier1 Standard Base Rate
- Changed label Floater Base Rate to Tier1 Floater Base Rate
- Changed label New Hire Standard Base Rate to Tier2 Standard Base Rate
- Changed label New Hire Floater Base Rate to Tier2 Floater Base Rate
|
2
|
Table
|
PS_NEC_BUS_UNIT_DT
|
Added two new columns NEC_T3_BASE_RATE, NEC_T3_FL_BASE_RT.
|
3
|
Stored Procedure
|
CALC_EMP_RATES
|
updated procedure to get 3rd tier from DB instead of hard-coding
|
4
|
Stored Procedure
|
USP_BU_GET
|
Update logic to pull two new columns added to PS_NEC_BUS_UNIT_DT table
|
5
|
Stored Procedure
|
USP_BUDT_INSERT
|
Update logic to insert and update tier 3 rates table and page.
|
6
|
Stored Procedure
|
USP_HR_REVIEWOPERATION_REPORT
|
updated procedure to get 3rd tier from DB instead of hard-coding
|
7
|
Stored Procedure
|
USP_NECRATE_RATESQL
|
updated procedure to get 3rd tier from DB instead of hard-coding
|
8
|
Stored Procedure
|
USP_RAPIDENTRY_INSRTUPDAT
|
updated procedure to get 3rd tier from DB instead of hard-coding
|
9
|
Stored Procedure
|
Usp_revemp_lotsize_change
|
updated procedure to get 3rd tier from DB instead of hard-coding
|
Test Notes
Polca New Changes Test Cases.xlsx
Reference Document (Specifications or Production Support Break Fix)
2013-02-26 - 4257.100 - Spec - Payroll Rate Change Procedure
|| Requirement || Test Case ID # || Test Case Name || Page Name || SubPage Name || Steps || Expected Results || Result || Pass/Fail Criteria ||